Quick Question: Table DDL For Storing Files

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Quick Question: Table DDL For Storing Files

Author

Topic

tkepongo
Yak Posting Veteran

62 Posts

Posted - 2011-08-25 : 14:04:41

After research, I've decided to store my files into a filesystem instead of the db. However, I am still unsure of how to structure this. Is my table below adequate?


CREATE TABLE Audit_Files
	(
	Audit_ID int,
	File_ID smallint,
	File_Name varchar (25),
	Extension varchar(5),
	File_Location varchar (50),
	)

And to open the file in Access 2007, I just refer to the File_Location right?

Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources