SQL命令创建表字段，不允许长度为零的字符串 [英] SQL Command CREATE TABLE FIELDS with not allowing zero length strings

问题描述

我想知道SQL中完整的命令以创建一个具有文本字段的能力，具有allowZeroLength = no.
我正在使用DAO 3.6，并且在帮助文件中找不到任何引用

我使用的命令是:

I want to know de complete command in SQL to create a able with a text field, having the allowZeroLength=no.
I'm using DAO 3.6 and in the help file didnt find any reference to it.

The command I use is:

Dim Engine As DAO.DBEngine = New DAO.DBEngine

Dim db As DAO.Database



db = Engine.CreateDatabase(Filename, LanguageConstants.dbLangGeneral)

dbDespesas.Execute("CREATE TABLE Streets ("ID COUNTER PRIMARY KEY,Name VARCHAR(20) NOT NULL UNIQUE)")

并且我想更改字段名称以不允许长度为零的文本.

And I want change de Field Name to not allow zero length text.

推荐答案

SQL Server开发人员之一中发布您的问题居中 > SQL Server论坛 > SQL Server入门位于以下位置:

Thank you for your post!  I would suggest posting your question in one of the SQL Server Developer Center > SQL Server Forums > Getting started with SQL Server  located here:  http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/threads.

这篇关于SQL命令创建表字段，不允许长度为零的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！